package com.ttj.domain.oracle.gen;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class BGoodsInventoryCriteria {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    protected Integer mysqlOffset;

    protected Integer mysqlLength;

    public BGoodsInventoryCriteria() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    /**
     * @param mysqlOffset 
	 *            指定返回记录行的偏移量<br>
	 *            mysqlOffset= 5,mysqlLength=10;  // 检索记录行 6-15
     */
    public void setMysqlOffset(Integer mysqlOffset) {
        this.mysqlOffset=mysqlOffset;
    }

    /**
     * @param mysqlLength 
	 *            指定返回记录行的最大数目<br>
	 *            mysqlOffset= 5,mysqlLength=10;  // 检索记录行 6-15
     */
    public Integer getMysqlOffset() {
        return mysqlOffset;
    }

    /**
     * @param mysqlOffset 
	 *            指定返回记录行的偏移量<br>
	 *            mysqlOffset= 5,mysqlLength=10;  // 检索记录行 6-15
     */
    public void setMysqlLength(Integer mysqlLength) {
        this.mysqlLength=mysqlLength;
    }

    /**
     * @param mysqlLength 
	 *            指定返回记录行的最大数目<br>
	 *            mysqlOffset= 5,mysqlLength=10;  // 检索记录行 6-15
     */
    public Integer getMysqlLength() {
        return mysqlLength;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("ID is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("ID is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Integer value) {
            addCriterion("ID =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Integer value) {
            addCriterion("ID <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Integer value) {
            addCriterion("ID >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("ID >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Integer value) {
            addCriterion("ID <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Integer value) {
            addCriterion("ID <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Integer> values) {
            addCriterion("ID in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Integer> values) {
            addCriterion("ID not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Integer value1, Integer value2) {
            addCriterion("ID between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Integer value1, Integer value2) {
            addCriterion("ID not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andNameIsNull() {
            addCriterion("NAME is null");
            return (Criteria) this;
        }

        public Criteria andNameIsNotNull() {
            addCriterion("NAME is not null");
            return (Criteria) this;
        }

        public Criteria andNameEqualTo(String value) {
            addCriterion("NAME =", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotEqualTo(String value) {
            addCriterion("NAME <>", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameGreaterThan(String value) {
            addCriterion("NAME >", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameGreaterThanOrEqualTo(String value) {
            addCriterion("NAME >=", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameLessThan(String value) {
            addCriterion("NAME <", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameLessThanOrEqualTo(String value) {
            addCriterion("NAME <=", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameLike(String value) {
            addCriterion("NAME like", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotLike(String value) {
            addCriterion("NAME not like", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameIn(List<String> values) {
            addCriterion("NAME in", values, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotIn(List<String> values) {
            addCriterion("NAME not in", values, "name");
            return (Criteria) this;
        }

        public Criteria andNameBetween(String value1, String value2) {
            addCriterion("NAME between", value1, value2, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotBetween(String value1, String value2) {
            addCriterion("NAME not between", value1, value2, "name");
            return (Criteria) this;
        }

        public Criteria andSIdIsNull() {
            addCriterion("S_ID is null");
            return (Criteria) this;
        }

        public Criteria andSIdIsNotNull() {
            addCriterion("S_ID is not null");
            return (Criteria) this;
        }

        public Criteria andSIdEqualTo(Integer value) {
            addCriterion("S_ID =", value, "sId");
            return (Criteria) this;
        }

        public Criteria andSIdNotEqualTo(Integer value) {
            addCriterion("S_ID <>", value, "sId");
            return (Criteria) this;
        }

        public Criteria andSIdGreaterThan(Integer value) {
            addCriterion("S_ID >", value, "sId");
            return (Criteria) this;
        }

        public Criteria andSIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("S_ID >=", value, "sId");
            return (Criteria) this;
        }

        public Criteria andSIdLessThan(Integer value) {
            addCriterion("S_ID <", value, "sId");
            return (Criteria) this;
        }

        public Criteria andSIdLessThanOrEqualTo(Integer value) {
            addCriterion("S_ID <=", value, "sId");
            return (Criteria) this;
        }

        public Criteria andSIdIn(List<Integer> values) {
            addCriterion("S_ID in", values, "sId");
            return (Criteria) this;
        }

        public Criteria andSIdNotIn(List<Integer> values) {
            addCriterion("S_ID not in", values, "sId");
            return (Criteria) this;
        }

        public Criteria andSIdBetween(Integer value1, Integer value2) {
            addCriterion("S_ID between", value1, value2, "sId");
            return (Criteria) this;
        }

        public Criteria andSIdNotBetween(Integer value1, Integer value2) {
            addCriterion("S_ID not between", value1, value2, "sId");
            return (Criteria) this;
        }

        public Criteria andTInNumIsNull() {
            addCriterion("T_IN_NUM is null");
            return (Criteria) this;
        }

        public Criteria andTInNumIsNotNull() {
            addCriterion("T_IN_NUM is not null");
            return (Criteria) this;
        }

        public Criteria andTInNumEqualTo(Integer value) {
            addCriterion("T_IN_NUM =", value, "tInNum");
            return (Criteria) this;
        }

        public Criteria andTInNumNotEqualTo(Integer value) {
            addCriterion("T_IN_NUM <>", value, "tInNum");
            return (Criteria) this;
        }

        public Criteria andTInNumGreaterThan(Integer value) {
            addCriterion("T_IN_NUM >", value, "tInNum");
            return (Criteria) this;
        }

        public Criteria andTInNumGreaterThanOrEqualTo(Integer value) {
            addCriterion("T_IN_NUM >=", value, "tInNum");
            return (Criteria) this;
        }

        public Criteria andTInNumLessThan(Integer value) {
            addCriterion("T_IN_NUM <", value, "tInNum");
            return (Criteria) this;
        }

        public Criteria andTInNumLessThanOrEqualTo(Integer value) {
            addCriterion("T_IN_NUM <=", value, "tInNum");
            return (Criteria) this;
        }

        public Criteria andTInNumIn(List<Integer> values) {
            addCriterion("T_IN_NUM in", values, "tInNum");
            return (Criteria) this;
        }

        public Criteria andTInNumNotIn(List<Integer> values) {
            addCriterion("T_IN_NUM not in", values, "tInNum");
            return (Criteria) this;
        }

        public Criteria andTInNumBetween(Integer value1, Integer value2) {
            addCriterion("T_IN_NUM between", value1, value2, "tInNum");
            return (Criteria) this;
        }

        public Criteria andTInNumNotBetween(Integer value1, Integer value2) {
            addCriterion("T_IN_NUM not between", value1, value2, "tInNum");
            return (Criteria) this;
        }

        public Criteria andTOutNumIsNull() {
            addCriterion("T_OUT_NUM is null");
            return (Criteria) this;
        }

        public Criteria andTOutNumIsNotNull() {
            addCriterion("T_OUT_NUM is not null");
            return (Criteria) this;
        }

        public Criteria andTOutNumEqualTo(Integer value) {
            addCriterion("T_OUT_NUM =", value, "tOutNum");
            return (Criteria) this;
        }

        public Criteria andTOutNumNotEqualTo(Integer value) {
            addCriterion("T_OUT_NUM <>", value, "tOutNum");
            return (Criteria) this;
        }

        public Criteria andTOutNumGreaterThan(Integer value) {
            addCriterion("T_OUT_NUM >", value, "tOutNum");
            return (Criteria) this;
        }

        public Criteria andTOutNumGreaterThanOrEqualTo(Integer value) {
            addCriterion("T_OUT_NUM >=", value, "tOutNum");
            return (Criteria) this;
        }

        public Criteria andTOutNumLessThan(Integer value) {
            addCriterion("T_OUT_NUM <", value, "tOutNum");
            return (Criteria) this;
        }

        public Criteria andTOutNumLessThanOrEqualTo(Integer value) {
            addCriterion("T_OUT_NUM <=", value, "tOutNum");
            return (Criteria) this;
        }

        public Criteria andTOutNumIn(List<Integer> values) {
            addCriterion("T_OUT_NUM in", values, "tOutNum");
            return (Criteria) this;
        }

        public Criteria andTOutNumNotIn(List<Integer> values) {
            addCriterion("T_OUT_NUM not in", values, "tOutNum");
            return (Criteria) this;
        }

        public Criteria andTOutNumBetween(Integer value1, Integer value2) {
            addCriterion("T_OUT_NUM between", value1, value2, "tOutNum");
            return (Criteria) this;
        }

        public Criteria andTOutNumNotBetween(Integer value1, Integer value2) {
            addCriterion("T_OUT_NUM not between", value1, value2, "tOutNum");
            return (Criteria) this;
        }

        public Criteria andTLoseNumIsNull() {
            addCriterion("T_LOSE_NUM is null");
            return (Criteria) this;
        }

        public Criteria andTLoseNumIsNotNull() {
            addCriterion("T_LOSE_NUM is not null");
            return (Criteria) this;
        }

        public Criteria andTLoseNumEqualTo(Integer value) {
            addCriterion("T_LOSE_NUM =", value, "tLoseNum");
            return (Criteria) this;
        }

        public Criteria andTLoseNumNotEqualTo(Integer value) {
            addCriterion("T_LOSE_NUM <>", value, "tLoseNum");
            return (Criteria) this;
        }

        public Criteria andTLoseNumGreaterThan(Integer value) {
            addCriterion("T_LOSE_NUM >", value, "tLoseNum");
            return (Criteria) this;
        }

        public Criteria andTLoseNumGreaterThanOrEqualTo(Integer value) {
            addCriterion("T_LOSE_NUM >=", value, "tLoseNum");
            return (Criteria) this;
        }

        public Criteria andTLoseNumLessThan(Integer value) {
            addCriterion("T_LOSE_NUM <", value, "tLoseNum");
            return (Criteria) this;
        }

        public Criteria andTLoseNumLessThanOrEqualTo(Integer value) {
            addCriterion("T_LOSE_NUM <=", value, "tLoseNum");
            return (Criteria) this;
        }

        public Criteria andTLoseNumIn(List<Integer> values) {
            addCriterion("T_LOSE_NUM in", values, "tLoseNum");
            return (Criteria) this;
        }

        public Criteria andTLoseNumNotIn(List<Integer> values) {
            addCriterion("T_LOSE_NUM not in", values, "tLoseNum");
            return (Criteria) this;
        }

        public Criteria andTLoseNumBetween(Integer value1, Integer value2) {
            addCriterion("T_LOSE_NUM between", value1, value2, "tLoseNum");
            return (Criteria) this;
        }

        public Criteria andTLoseNumNotBetween(Integer value1, Integer value2) {
            addCriterion("T_LOSE_NUM not between", value1, value2, "tLoseNum");
            return (Criteria) this;
        }

        public Criteria andTSreturnNumIsNull() {
            addCriterion("T_SRETURN_NUM is null");
            return (Criteria) this;
        }

        public Criteria andTSreturnNumIsNotNull() {
            addCriterion("T_SRETURN_NUM is not null");
            return (Criteria) this;
        }

        public Criteria andTSreturnNumEqualTo(Integer value) {
            addCriterion("T_SRETURN_NUM =", value, "tSreturnNum");
            return (Criteria) this;
        }

        public Criteria andTSreturnNumNotEqualTo(Integer value) {
            addCriterion("T_SRETURN_NUM <>", value, "tSreturnNum");
            return (Criteria) this;
        }

        public Criteria andTSreturnNumGreaterThan(Integer value) {
            addCriterion("T_SRETURN_NUM >", value, "tSreturnNum");
            return (Criteria) this;
        }

        public Criteria andTSreturnNumGreaterThanOrEqualTo(Integer value) {
            addCriterion("T_SRETURN_NUM >=", value, "tSreturnNum");
            return (Criteria) this;
        }

        public Criteria andTSreturnNumLessThan(Integer value) {
            addCriterion("T_SRETURN_NUM <", value, "tSreturnNum");
            return (Criteria) this;
        }

        public Criteria andTSreturnNumLessThanOrEqualTo(Integer value) {
            addCriterion("T_SRETURN_NUM <=", value, "tSreturnNum");
            return (Criteria) this;
        }

        public Criteria andTSreturnNumIn(List<Integer> values) {
            addCriterion("T_SRETURN_NUM in", values, "tSreturnNum");
            return (Criteria) this;
        }

        public Criteria andTSreturnNumNotIn(List<Integer> values) {
            addCriterion("T_SRETURN_NUM not in", values, "tSreturnNum");
            return (Criteria) this;
        }

        public Criteria andTSreturnNumBetween(Integer value1, Integer value2) {
            addCriterion("T_SRETURN_NUM between", value1, value2, "tSreturnNum");
            return (Criteria) this;
        }

        public Criteria andTSreturnNumNotBetween(Integer value1, Integer value2) {
            addCriterion("T_SRETURN_NUM not between", value1, value2, "tSreturnNum");
            return (Criteria) this;
        }

        public Criteria andTCreturnNumIsNull() {
            addCriterion("T_CRETURN_NUM is null");
            return (Criteria) this;
        }

        public Criteria andTCreturnNumIsNotNull() {
            addCriterion("T_CRETURN_NUM is not null");
            return (Criteria) this;
        }

        public Criteria andTCreturnNumEqualTo(Integer value) {
            addCriterion("T_CRETURN_NUM =", value, "tCreturnNum");
            return (Criteria) this;
        }

        public Criteria andTCreturnNumNotEqualTo(Integer value) {
            addCriterion("T_CRETURN_NUM <>", value, "tCreturnNum");
            return (Criteria) this;
        }

        public Criteria andTCreturnNumGreaterThan(Integer value) {
            addCriterion("T_CRETURN_NUM >", value, "tCreturnNum");
            return (Criteria) this;
        }

        public Criteria andTCreturnNumGreaterThanOrEqualTo(Integer value) {
            addCriterion("T_CRETURN_NUM >=", value, "tCreturnNum");
            return (Criteria) this;
        }

        public Criteria andTCreturnNumLessThan(Integer value) {
            addCriterion("T_CRETURN_NUM <", value, "tCreturnNum");
            return (Criteria) this;
        }

        public Criteria andTCreturnNumLessThanOrEqualTo(Integer value) {
            addCriterion("T_CRETURN_NUM <=", value, "tCreturnNum");
            return (Criteria) this;
        }

        public Criteria andTCreturnNumIn(List<Integer> values) {
            addCriterion("T_CRETURN_NUM in", values, "tCreturnNum");
            return (Criteria) this;
        }

        public Criteria andTCreturnNumNotIn(List<Integer> values) {
            addCriterion("T_CRETURN_NUM not in", values, "tCreturnNum");
            return (Criteria) this;
        }

        public Criteria andTCreturnNumBetween(Integer value1, Integer value2) {
            addCriterion("T_CRETURN_NUM between", value1, value2, "tCreturnNum");
            return (Criteria) this;
        }

        public Criteria andTCreturnNumNotBetween(Integer value1, Integer value2) {
            addCriterion("T_CRETURN_NUM not between", value1, value2, "tCreturnNum");
            return (Criteria) this;
        }

        public Criteria andLastIndateIsNull() {
            addCriterion("LAST_INDATE is null");
            return (Criteria) this;
        }

        public Criteria andLastIndateIsNotNull() {
            addCriterion("LAST_INDATE is not null");
            return (Criteria) this;
        }

        public Criteria andLastIndateEqualTo(Date value) {
            addCriterion("LAST_INDATE =", value, "lastIndate");
            return (Criteria) this;
        }

        public Criteria andLastIndateNotEqualTo(Date value) {
            addCriterion("LAST_INDATE <>", value, "lastIndate");
            return (Criteria) this;
        }

        public Criteria andLastIndateGreaterThan(Date value) {
            addCriterion("LAST_INDATE >", value, "lastIndate");
            return (Criteria) this;
        }

        public Criteria andLastIndateGreaterThanOrEqualTo(Date value) {
            addCriterion("LAST_INDATE >=", value, "lastIndate");
            return (Criteria) this;
        }

        public Criteria andLastIndateLessThan(Date value) {
            addCriterion("LAST_INDATE <", value, "lastIndate");
            return (Criteria) this;
        }

        public Criteria andLastIndateLessThanOrEqualTo(Date value) {
            addCriterion("LAST_INDATE <=", value, "lastIndate");
            return (Criteria) this;
        }

        public Criteria andLastIndateIn(List<Date> values) {
            addCriterion("LAST_INDATE in", values, "lastIndate");
            return (Criteria) this;
        }

        public Criteria andLastIndateNotIn(List<Date> values) {
            addCriterion("LAST_INDATE not in", values, "lastIndate");
            return (Criteria) this;
        }

        public Criteria andLastIndateBetween(Date value1, Date value2) {
            addCriterion("LAST_INDATE between", value1, value2, "lastIndate");
            return (Criteria) this;
        }

        public Criteria andLastIndateNotBetween(Date value1, Date value2) {
            addCriterion("LAST_INDATE not between", value1, value2, "lastIndate");
            return (Criteria) this;
        }

        public Criteria andLastNumIsNull() {
            addCriterion("LAST_NUM is null");
            return (Criteria) this;
        }

        public Criteria andLastNumIsNotNull() {
            addCriterion("LAST_NUM is not null");
            return (Criteria) this;
        }

        public Criteria andLastNumEqualTo(Integer value) {
            addCriterion("LAST_NUM =", value, "lastNum");
            return (Criteria) this;
        }

        public Criteria andLastNumNotEqualTo(Integer value) {
            addCriterion("LAST_NUM <>", value, "lastNum");
            return (Criteria) this;
        }

        public Criteria andLastNumGreaterThan(Integer value) {
            addCriterion("LAST_NUM >", value, "lastNum");
            return (Criteria) this;
        }

        public Criteria andLastNumGreaterThanOrEqualTo(Integer value) {
            addCriterion("LAST_NUM >=", value, "lastNum");
            return (Criteria) this;
        }

        public Criteria andLastNumLessThan(Integer value) {
            addCriterion("LAST_NUM <", value, "lastNum");
            return (Criteria) this;
        }

        public Criteria andLastNumLessThanOrEqualTo(Integer value) {
            addCriterion("LAST_NUM <=", value, "lastNum");
            return (Criteria) this;
        }

        public Criteria andLastNumIn(List<Integer> values) {
            addCriterion("LAST_NUM in", values, "lastNum");
            return (Criteria) this;
        }

        public Criteria andLastNumNotIn(List<Integer> values) {
            addCriterion("LAST_NUM not in", values, "lastNum");
            return (Criteria) this;
        }

        public Criteria andLastNumBetween(Integer value1, Integer value2) {
            addCriterion("LAST_NUM between", value1, value2, "lastNum");
            return (Criteria) this;
        }

        public Criteria andLastNumNotBetween(Integer value1, Integer value2) {
            addCriterion("LAST_NUM not between", value1, value2, "lastNum");
            return (Criteria) this;
        }

        public Criteria andCurNumIsNull() {
            addCriterion("CUR_NUM is null");
            return (Criteria) this;
        }

        public Criteria andCurNumIsNotNull() {
            addCriterion("CUR_NUM is not null");
            return (Criteria) this;
        }

        public Criteria andCurNumEqualTo(Integer value) {
            addCriterion("CUR_NUM =", value, "curNum");
            return (Criteria) this;
        }

        public Criteria andCurNumNotEqualTo(Integer value) {
            addCriterion("CUR_NUM <>", value, "curNum");
            return (Criteria) this;
        }

        public Criteria andCurNumGreaterThan(Integer value) {
            addCriterion("CUR_NUM >", value, "curNum");
            return (Criteria) this;
        }

        public Criteria andCurNumGreaterThanOrEqualTo(Integer value) {
            addCriterion("CUR_NUM >=", value, "curNum");
            return (Criteria) this;
        }

        public Criteria andCurNumLessThan(Integer value) {
            addCriterion("CUR_NUM <", value, "curNum");
            return (Criteria) this;
        }

        public Criteria andCurNumLessThanOrEqualTo(Integer value) {
            addCriterion("CUR_NUM <=", value, "curNum");
            return (Criteria) this;
        }

        public Criteria andCurNumIn(List<Integer> values) {
            addCriterion("CUR_NUM in", values, "curNum");
            return (Criteria) this;
        }

        public Criteria andCurNumNotIn(List<Integer> values) {
            addCriterion("CUR_NUM not in", values, "curNum");
            return (Criteria) this;
        }

        public Criteria andCurNumBetween(Integer value1, Integer value2) {
            addCriterion("CUR_NUM between", value1, value2, "curNum");
            return (Criteria) this;
        }

        public Criteria andCurNumNotBetween(Integer value1, Integer value2) {
            addCriterion("CUR_NUM not between", value1, value2, "curNum");
            return (Criteria) this;
        }

        public Criteria andCostIsNull() {
            addCriterion("COST is null");
            return (Criteria) this;
        }

        public Criteria andCostIsNotNull() {
            addCriterion("COST is not null");
            return (Criteria) this;
        }

        public Criteria andCostEqualTo(Double value) {
            addCriterion("COST =", value, "cost");
            return (Criteria) this;
        }

        public Criteria andCostNotEqualTo(Double value) {
            addCriterion("COST <>", value, "cost");
            return (Criteria) this;
        }

        public Criteria andCostGreaterThan(Double value) {
            addCriterion("COST >", value, "cost");
            return (Criteria) this;
        }

        public Criteria andCostGreaterThanOrEqualTo(Double value) {
            addCriterion("COST >=", value, "cost");
            return (Criteria) this;
        }

        public Criteria andCostLessThan(Double value) {
            addCriterion("COST <", value, "cost");
            return (Criteria) this;
        }

        public Criteria andCostLessThanOrEqualTo(Double value) {
            addCriterion("COST <=", value, "cost");
            return (Criteria) this;
        }

        public Criteria andCostIn(List<Double> values) {
            addCriterion("COST in", values, "cost");
            return (Criteria) this;
        }

        public Criteria andCostNotIn(List<Double> values) {
            addCriterion("COST not in", values, "cost");
            return (Criteria) this;
        }

        public Criteria andCostBetween(Double value1, Double value2) {
            addCriterion("COST between", value1, value2, "cost");
            return (Criteria) this;
        }

        public Criteria andCostNotBetween(Double value1, Double value2) {
            addCriterion("COST not between", value1, value2, "cost");
            return (Criteria) this;
        }

        public Criteria andTcostIsNull() {
            addCriterion("TCOST is null");
            return (Criteria) this;
        }

        public Criteria andTcostIsNotNull() {
            addCriterion("TCOST is not null");
            return (Criteria) this;
        }

        public Criteria andTcostEqualTo(Double value) {
            addCriterion("TCOST =", value, "tcost");
            return (Criteria) this;
        }

        public Criteria andTcostNotEqualTo(Double value) {
            addCriterion("TCOST <>", value, "tcost");
            return (Criteria) this;
        }

        public Criteria andTcostGreaterThan(Double value) {
            addCriterion("TCOST >", value, "tcost");
            return (Criteria) this;
        }

        public Criteria andTcostGreaterThanOrEqualTo(Double value) {
            addCriterion("TCOST >=", value, "tcost");
            return (Criteria) this;
        }

        public Criteria andTcostLessThan(Double value) {
            addCriterion("TCOST <", value, "tcost");
            return (Criteria) this;
        }

        public Criteria andTcostLessThanOrEqualTo(Double value) {
            addCriterion("TCOST <=", value, "tcost");
            return (Criteria) this;
        }

        public Criteria andTcostIn(List<Double> values) {
            addCriterion("TCOST in", values, "tcost");
            return (Criteria) this;
        }

        public Criteria andTcostNotIn(List<Double> values) {
            addCriterion("TCOST not in", values, "tcost");
            return (Criteria) this;
        }

        public Criteria andTcostBetween(Double value1, Double value2) {
            addCriterion("TCOST between", value1, value2, "tcost");
            return (Criteria) this;
        }

        public Criteria andTcostNotBetween(Double value1, Double value2) {
            addCriterion("TCOST not between", value1, value2, "tcost");
            return (Criteria) this;
        }

        public Criteria andCurTruenumIsNull() {
            addCriterion("CUR_TRUENUM is null");
            return (Criteria) this;
        }

        public Criteria andCurTruenumIsNotNull() {
            addCriterion("CUR_TRUENUM is not null");
            return (Criteria) this;
        }

        public Criteria andCurTruenumEqualTo(Integer value) {
            addCriterion("CUR_TRUENUM =", value, "curTruenum");
            return (Criteria) this;
        }

        public Criteria andCurTruenumNotEqualTo(Integer value) {
            addCriterion("CUR_TRUENUM <>", value, "curTruenum");
            return (Criteria) this;
        }

        public Criteria andCurTruenumGreaterThan(Integer value) {
            addCriterion("CUR_TRUENUM >", value, "curTruenum");
            return (Criteria) this;
        }

        public Criteria andCurTruenumGreaterThanOrEqualTo(Integer value) {
            addCriterion("CUR_TRUENUM >=", value, "curTruenum");
            return (Criteria) this;
        }

        public Criteria andCurTruenumLessThan(Integer value) {
            addCriterion("CUR_TRUENUM <", value, "curTruenum");
            return (Criteria) this;
        }

        public Criteria andCurTruenumLessThanOrEqualTo(Integer value) {
            addCriterion("CUR_TRUENUM <=", value, "curTruenum");
            return (Criteria) this;
        }

        public Criteria andCurTruenumIn(List<Integer> values) {
            addCriterion("CUR_TRUENUM in", values, "curTruenum");
            return (Criteria) this;
        }

        public Criteria andCurTruenumNotIn(List<Integer> values) {
            addCriterion("CUR_TRUENUM not in", values, "curTruenum");
            return (Criteria) this;
        }

        public Criteria andCurTruenumBetween(Integer value1, Integer value2) {
            addCriterion("CUR_TRUENUM between", value1, value2, "curTruenum");
            return (Criteria) this;
        }

        public Criteria andCurTruenumNotBetween(Integer value1, Integer value2) {
            addCriterion("CUR_TRUENUM not between", value1, value2, "curTruenum");
            return (Criteria) this;
        }

        public Criteria andTypeIsNull() {
            addCriterion("TYPE is null");
            return (Criteria) this;
        }

        public Criteria andTypeIsNotNull() {
            addCriterion("TYPE is not null");
            return (Criteria) this;
        }

        public Criteria andTypeEqualTo(Integer value) {
            addCriterion("TYPE =", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeNotEqualTo(Integer value) {
            addCriterion("TYPE <>", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeGreaterThan(Integer value) {
            addCriterion("TYPE >", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("TYPE >=", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeLessThan(Integer value) {
            addCriterion("TYPE <", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeLessThanOrEqualTo(Integer value) {
            addCriterion("TYPE <=", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeIn(List<Integer> values) {
            addCriterion("TYPE in", values, "type");
            return (Criteria) this;
        }

        public Criteria andTypeNotIn(List<Integer> values) {
            addCriterion("TYPE not in", values, "type");
            return (Criteria) this;
        }

        public Criteria andTypeBetween(Integer value1, Integer value2) {
            addCriterion("TYPE between", value1, value2, "type");
            return (Criteria) this;
        }

        public Criteria andTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("TYPE not between", value1, value2, "type");
            return (Criteria) this;
        }
    }

    /**
     * This class was generated by MyBatis Generator.
     * This class corresponds to the database table B_GOODS_INVENTORY
     *
     * @mbg.generated do_not_delete_during_merge Wed Jul 12 08:41:20 CST 2017
     */
    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}